********************************************************************************
* Balyuk, Berger, and Hackney (2024)                                           *
* "What is Fueling FinTech Lending? The Role of Banking Market Structure"      *
* The Review of Corporate Financial Studies                                    *
********************************************************************************

clear all
clear matrix

************************   Table I, Columns (1)-(3)   **************************

* open file *

	use "$code/DATA_Prosper_annual_county_w.dta", clear
	
* Panel A *	
	
	tabstat Ysb1_P Dsb_P Esb_P, s(N mean median sd) c(s)
			
* Panel B *		
			
	tabstat large_bank_l large_bank_access_l ///
			small_bank_access_l large_bank2_P_l ///
			small_bank2_P_l out_100_P_l in_100_P_l ///
			out_large2_100_P_l in_large2_100_P_l ///
			out_small2_100_P_l in_small2_100_P_l, ///
			s(N mean median sd) c(s)
			
* Panel C *		
			
	tabstat pop_l median_income_l unemployment_l house_price_chg_l rurality, ///
			s(N mean median sd) c(s)

* Panel D *	
			
	tabstat bank_access_l deposits_l eq_capital_ratio_l liquidity2gta_l ///
			ROA_l nonperf2loans_l, s(N mean median sd) c(s)			

************************   Table I, Columns (4)-(6)   **************************

clear all
clear matrix

* open file - PSEUDO data *

	use "$code/DATA_FC_annual_county_w_pseudo.dta", clear
	
* Panel A *	
	
	tabstat Ysb1_FC_pseudo, s(N mean median sd) c(s)
			
* Panel B *		
			
	tabstat large_bank_l_pseudo large_bank_access_l_pseudo ///
			small_bank_access_l_pseudo large_bank2_P_l_pseudo ///
			small_bank2_P_l_pseudo out_100_P_l_pseudo in_100_P_l_pseudo ///
			out_large2_100_P_l_pseudo in_large2_100_P_l_pseudo ///
			out_small2_100_P_l_pseudo in_small2_100_P_l_pseudo, ///
			s(N mean median sd) c(s)
			
* Panel C *		
			
	tabstat pop_l median_income_l unemployment_l house_price_chg_l rurality, ///
			s(N mean median sd) c(s)

* Panel D *	
			
	tabstat bank_access_l deposits_l eq_capital_ratio_l liquidity2gta_l ///
			ROA_l nonperf2loans_l, s(N mean median sd) c(s)			
